<?php
pdo_query("DROP TABLE IF EXISTS `ims_meepo_xianchang_3d_config`;
CREATE TABLE IF NOT EXISTS `ims_meepo_xianchang_3d_config` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`weid` int(10) NOT NULL,
`rid` int(10) NOT NULL DEFAULT '0',
`placeholder_image_arr` text NOT NULL,
`str` text NOT NULL,
`count_down_on` tinyint(1) NOT NULL DEFAULT '1',
`count_down_time` int(2) NOT NULL DEFAULT '9',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `ims_meepo_xianchang_basic_config`;
CREATE TABLE IF NOT EXISTS `ims_meepo_xianchang_basic_config` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`weid` int(10) NOT NULL,
`rid` int(10) NOT NULL DEFAULT '0',
`mp_name` varchar(300) NOT NULL,
`mp_img` varchar(300) NOT NULL,
`top_img` varchar(300) NOT NULL,
`top_title` varchar(2000) NOT NULL,
`top_font_size` varchar(10) NOT NULL,
`bottom_img` varchar(300) NOT NULL,
`bg_img` varchar(300) NOT NULL,
`bottom_words` varchar(300) NOT NULL,
`show_star` tinyint(1) NOT NULL DEFAULT '0',
`show_leaf` tinyint(1) NOT NULL DEFAULT '1',
`leaf_style` tinyint(1) NOT NULL DEFAULT '1',
`basic_style` varchar(10) NOT NULL,
`bg_music_on` tinyint(1) NOT NULL DEFAULT '0',
`bg_music` varchar(300) NOT NULL,
`bg_vedio` varchar(500) NOT NULL,
`diy_css` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `ims_meepo_xianchang_bd`;
CREATE TABLE IF NOT EXISTS `ims_meepo_xianchang_bd` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`weid` int(10) NOT NULL,
`rid` int(10) NOT NULL DEFAULT '0',
`show` tinyint(1) NOT NULL DEFAULT '1',
`xm` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `ims_meepo_xianchang_bd_data`;
CREATE TABLE IF NOT EXISTS `ims_meepo_xianchang_bd_data` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`weid` int(10) NOT NULL,
`rid` int(10) NOT NULL DEFAULT '0',
`openid` varchar(100) NOT NULL,
`data` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `ims_meepo_xianchang_cookie`;
CREATE TABLE IF NOT EXISTS `ims_meepo_xianchang_cookie` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`weid` int(10) NOT NULL,
`rid` int(10) NOT NULL DEFAULT '0',
`cookie` varchar(300) NOT NULL,
`createtime` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

INSERT INTO `ims_meepo_xianchang_cookie` VALUES ('1','1','1','meepo','0')

DROP TABLE IF EXISTS `ims_meepo_xianchang_jb`;
CREATE TABLE IF NOT EXISTS `ims_meepo_xianchang_jb` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`weid` int(10) NOT NULL,
`rid` int(10) NOT NULL DEFAULT '0',
`displayid` int(10) NOT NULL DEFAULT '0',
`name` varchar(300) NOT NULL,
`tx` varchar(300) NOT NULL,
`des` text NOT NULL,
`createtime` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `ims_meepo_xianchang_lottory_award`;
CREATE TABLE IF NOT EXISTS `ims_meepo_xianchang_lottory_award` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`displayid` int(11) NOT NULL,
`weid` int(10) NOT NULL,
`rid` int(10) NOT NULL DEFAULT '0',
`tag_num` int(11) NOT NULL DEFAULT '3',
`luck_name` varchar(300) NOT NULL,
`luck_img` varchar(300) NOT NULL,
`tag_name` varchar(100) NOT NULL,
`nd_id` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `ims_meepo_xianchang_lottory_config`;
CREATE TABLE IF NOT EXISTS `ims_meepo_xianchang_lottory_config` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`weid` int(10) NOT NULL,
`rid` int(10) NOT NULL DEFAULT '0',
`title` varchar(200) NOT NULL,
`send_mess` tinyint(1) NOT NULL DEFAULT '0',
`def_mess` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `ims_meepo_xianchang_lottory_user`;
CREATE TABLE IF NOT EXISTS `ims_meepo_xianchang_lottory_user` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`weid` int(10) NOT NULL,
`rid` int(10) NOT NULL DEFAULT '0',
`openid` varchar(100) NOT NULL,
`nick_name` varchar(300) NOT NULL,
`avatar` varchar(300) NOT NULL,
`user_id` int(11) NOT NULL,
`lottory_id` int(11) NOT NULL,
`createtime` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `ims_meepo_xianchang_qd`;
CREATE TABLE IF NOT EXISTS `ims_meepo_xianchang_qd` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`weid` int(10) NOT NULL,
`rid` int(10) NOT NULL DEFAULT '0',
`openid` varchar(100) NOT NULL,
`nick_name` varchar(100) NOT NULL,
`avatar` varchar(300) NOT NULL,
`level` int(1) NOT NULL DEFAULT '2',
`createtime` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `ims_meepo_xianchang_qd_config`;
CREATE TABLE IF NOT EXISTS `ims_meepo_xianchang_qd_config` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`weid` int(10) NOT NULL,
`rid` int(10) NOT NULL DEFAULT '0',
`status` int(1) NOT NULL DEFAULT '1',
`title` varchar(300) NOT NULL DEFAULT '签到',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `ims_meepo_xianchang_redpack_config`;
CREATE TABLE IF NOT EXISTS `ims_meepo_xianchang_redpack_config` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`weid` int(10) NOT NULL,
`rid` int(10) NOT NULL DEFAULT '0',
`tip_words` text NOT NULL,
`guize` text NOT NULL,
`weixin_pay` tinyint(1) NOT NULL DEFAULT '0',
`appid` varchar(100) NOT NULL,
`secret` varchar(100) NOT NULL,
`mchid` varchar(30) NOT NULL,
`signkey` varchar(100) NOT NULL,
`ip` varchar(30) NOT NULL,
`_desc` varchar(100) NOT NULL,
`all_nums` int(11) NOT NULL DEFAULT '2',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `ims_meepo_xianchang_redpack_rotate`;
CREATE TABLE IF NOT EXISTS `ims_meepo_xianchang_redpack_rotate` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`weid` int(10) NOT NULL,
`rid` int(10) NOT NULL DEFAULT '0',
`status` tinyint(1) NOT NULL DEFAULT '1',
`type` tinyint(1) NOT NULL DEFAULT '1',
`money` varchar(100) NOT NULL DEFAULT '6.6',
`all_money` varchar(100) NOT NULL DEFAULT '6.6',
`min` varchar(100) NOT NULL DEFAULT '1',
`max` varchar(100) NOT NULL DEFAULT '8.8',
`redpack_num` int(10) NOT NULL,
`get_num` int(10) NOT NULL DEFAULT '1',
`gailv` int(10) NOT NULL DEFAULT '50',
`countdown` int(10) NOT NULL DEFAULT '60',
`zzs` varchar(500) NOT NULL,
`createtime` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `ims_meepo_xianchang_redpack_user`;
CREATE TABLE IF NOT EXISTS `ims_meepo_xianchang_redpack_user` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`weid` int(10) NOT NULL,
`rid` int(10) NOT NULL DEFAULT '0',
`rotate_id` int(10) NOT NULL,
`openid` varchar(100) NOT NULL,
`nick_name` varchar(300) NOT NULL,
`avatar` varchar(300) NOT NULL,
`money` varchar(100) NOT NULL DEFAULT '0.0',
`createtime` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `ims_meepo_xianchang_rid`;
CREATE TABLE IF NOT EXISTS `ims_meepo_xianchang_rid` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`weid` int(10) NOT NULL,
`rid` int(10) NOT NULL DEFAULT '0',
`title` varchar(200) NOT NULL,
`start_time` int(11) NOT NULL,
`end_time` int(11) NOT NULL,
`controls` text NOT NULL,
`gz_must` tinyint(1) NOT NULL DEFAULT '0',
`gz_url` varchar(300) NOT NULL,
`pass_word` varchar(20) NOT NULL,
`status` tinyint(1) NOT NULL DEFAULT '1',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `ims_meepo_xianchang_shake_config`;
CREATE TABLE IF NOT EXISTS `ims_meepo_xianchang_shake_config` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`weid` int(10) NOT NULL,
`rid` int(10) NOT NULL DEFAULT '0',
`ready_time` int(10) NOT NULL DEFAULT '5',
`title` varchar(200) NOT NULL,
`paodao_color` varchar(100) NOT NULL,
`shake_music` varchar(300) NOT NULL,
`pp_img` varchar(300) NOT NULL,
`app_bg` varchar(300) NOT NULL,
`point` int(11) NOT NULL,
`award_again` tinyint(1) NOT NULL DEFAULT '2',
`slogan` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `ims_meepo_xianchang_shake_rotate`;
CREATE TABLE IF NOT EXISTS `ims_meepo_xianchang_shake_rotate` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`weid` int(10) NOT NULL,
`rid` int(10) NOT NULL DEFAULT '0',
`pnum` int(10) NOT NULL DEFAULT '10',
`status` tinyint(1) NOT NULL DEFAULT '1',
`createtime` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `ims_meepo_xianchang_shake_user`;
CREATE TABLE IF NOT EXISTS `ims_meepo_xianchang_shake_user` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`weid` int(10) NOT NULL,
`rid` int(10) NOT NULL DEFAULT '0',
`rotate_id` int(10) NOT NULL,
`count` int(11) NOT NULL DEFAULT '0',
`award` tinyint(1) NOT NULL DEFAULT '0',
`openid` varchar(100) NOT NULL,
`nick_name` varchar(300) NOT NULL,
`avatar` varchar(300) NOT NULL,
`createtime` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `ims_meepo_xianchang_user`;
CREATE TABLE IF NOT EXISTS `ims_meepo_xianchang_user` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`weid` int(10) NOT NULL,
`rid` int(10) NOT NULL DEFAULT '0',
`openid` varchar(100) NOT NULL,
`nick_name` varchar(300) NOT NULL,
`avatar` varchar(300) NOT NULL,
`sex` varchar(2) NOT NULL DEFAULT '0',
`group` int(10) NOT NULL DEFAULT '0',
`status` tinyint(1) NOT NULL DEFAULT '1',
`isblacklist` tinyint(1) NOT NULL DEFAULT '1',
`can_lottory` tinyint(1) NOT NULL DEFAULT '1',
`nd_id` int(11) NOT NULL DEFAULT '0',
`createtime` int(11) NOT NULL,
`mobile` varchar(20) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `ims_meepo_xianchang_vote`;
CREATE TABLE IF NOT EXISTS `ims_meepo_xianchang_vote` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`weid` int(10) NOT NULL,
`rid` int(10) NOT NULL DEFAULT '0',
`title` varchar(300) NOT NULL,
`status` tinyint(1) NOT NULL DEFAULT '1',
`show_style` tinyint(1) NOT NULL,
`vote_zhuti` varchar(300) NOT NULL,
`vote_zhuti_img` varchar(300) NOT NULL,
`vote_zhuti_des` text NOT NULL,
`vote_more` tinyint(1) NOT NULL DEFAULT '1',
`vote_nums` int(11) NOT NULL DEFAULT '2',
`vote_start_time` int(11) NOT NULL,
`vote_end_time` int(11) NOT NULL,
`vote_show_result` tinyint(1) NOT NULL DEFAULT '1',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `ims_meepo_xianchang_vote_record`;
CREATE TABLE IF NOT EXISTS `ims_meepo_xianchang_vote_record` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`weid` int(10) NOT NULL,
`rid` int(10) NOT NULL DEFAULT '0',
`fid` int(11) NOT NULL DEFAULT '0',
`vote_xm_id` int(11) NOT NULL DEFAULT '0',
`openid` varchar(100) NOT NULL,
`nick_name` varchar(300) NOT NULL,
`avatar` varchar(300) NOT NULL,
`createtime` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `ims_meepo_xianchang_vote_xms`;
CREATE TABLE IF NOT EXISTS `ims_meepo_xianchang_vote_xms` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`weid` int(10) NOT NULL,
`rid` int(10) NOT NULL DEFAULT '0',
`fid` int(11) NOT NULL DEFAULT '0',
`displayid` int(11) NOT NULL DEFAULT '0',
`name` varchar(300) NOT NULL DEFAULT '2',
`img` varchar(300) NOT NULL,
`nums` int(11) NOT NULL DEFAULT '0',
`show_style` tinyint(1) NOT NULL DEFAULT '1',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `ims_meepo_xianchang_wall`;
CREATE TABLE IF NOT EXISTS `ims_meepo_xianchang_wall` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`weid` int(10) NOT NULL,
`rid` int(10) NOT NULL DEFAULT '0',
`openid` varchar(120) NOT NULL,
`nick_name` varchar(300) NOT NULL,
`avatar` varchar(300) NOT NULL,
`content` text NOT NULL,
`type` tinyint(1) NOT NULL DEFAULT '1',
`status` tinyint(1) NOT NULL DEFAULT '1',
`createtime` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `ims_meepo_xianchang_wall_config`;
CREATE TABLE IF NOT EXISTS `ims_meepo_xianchang_wall_config` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`weid` int(10) NOT NULL,
`rid` int(10) NOT NULL DEFAULT '0',
`status` int(1) NOT NULL DEFAULT '1',
`title` varchar(500) NOT NULL,
`show_style` tinyint(1) NOT NULL DEFAULT '0',
`show_type` tinyint(1) NOT NULL DEFAULT '0',
`show_big` tinyint(1) NOT NULL DEFAULT '0',
`show_big_time` int(11) NOT NULL DEFAULT '3',
`re_time` int(10) NOT NULL DEFAULT '3',
`show_time` int(10) NOT NULL DEFAULT '0',
`chistory` int(10) NOT NULL DEFAULT '50',
`forbidden_words` text NOT NULL,
`maxlength` int(11) NOT NULL DEFAULT '0',
`input_count` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `ims_meepo_xianchang_xc`;
CREATE TABLE IF NOT EXISTS `ims_meepo_xianchang_xc` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`weid` int(10) NOT NULL,
`rid` int(10) NOT NULL DEFAULT '0',
`displayid` int(10) NOT NULL DEFAULT '0',
`img` varchar(300) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

");
